﻿CREATE VIEW [dbo].[vwHours]
AS
SELECT     TOP 100 PERCENT e.EntryDate, e.Duration AS Hours, p.Name AS ProjectName, u.UserName
FROM         dbo.EntryLog e INNER JOIN
                      dbo.Projects p ON e.ProjectID = p.ProjectID INNER JOIN
                      dbo.Users u ON e.UserID = u.UserID
ORDER BY p.Name;

